SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422930 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422930 [ RunTime:0.002096s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88156,19263,77557,105217,561892,387482,509111,926588,593629,565724,41408,726198,1028516,38609,793894,337372,749764,258765,931945,46138,177661,38564,972003,677183,233523,116942,307075,1013801,789767,298483,1027042,184179,1015990,725193,79379,421536,248179,1048383,539358,189029,487034,611679,62034,1016901,94641,548932,863032,713898,575850,301145,614432,26828,142936,345820,553772,85411,596110,808179,185680,736972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]