SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 181012 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 181012 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387642,1933,97731,825298,289467,944411,227262,723131,5182,771083,913248,994339,166443,367285,288755,385412,231353,508559,500076,906994,482080,515539,999084,803494,145374,72301,689672,472571,640775,497383,264916,949041,395226,823552,472797,742019,767577,26549,921620,586555,641618,241539,1042983,535580,935452,997975,480604,128338,874488,268096,493048,969776,265599,848832,466647,971997,578123,901994,492663,1027172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 181012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 181012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]