SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001519s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343408 LIMIT 1 [ RunTime:0.000641s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343408 [ RunTime:0.002836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157796,328560,782808,206333,265850,831036,1030804,217005,633796,250968,88911,76883,348189,224906,615382,320928,810156,591707,553976,497145,969579,602366,354220,705313,399542,735981,970111,872167,961553,251054,743790,975187,53870,832989,546634,945796,432891,832246,644985,287888,549148,347036,522914,488052,815299,765362,631671,455379,276079,908494,299116,222546,1008659,631142,869004,762023,121504,350996,313610,544700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000880s ]