SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043886 LIMIT 1 [ RunTime:0.001296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043886 [ RunTime:0.003993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659896,497902,870138,516651,862563,108954,973065,1031655,978851,762564,886236,965884,670265,209021,875921,190362,911441,711750,259601,14398,248970,523433,967748,359084,15837,219993,1017490,567566,266436,317495,917541,735379,484580,629484,557320,408918,636230,571452,762559,897618,711179,871160,200935,809345,818533,245002,496570,296380,919205,81157,1009072,171093,908052,927535,233443,750898,695946,40202,169080,184066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043886 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043886 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]