SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001595s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554083 LIMIT 1 [ RunTime:0.000572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554083 [ RunTime:0.003679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606535,959578,742416,68218,517518,218031,447464,98100,537529,508964,210424,891865,11571,587876,143217,737267,31745,72598,958629,322915,646205,494884,653547,36922,902286,97243,105936,154071,465317,272655,17361,860120,462094,304330,190752,545037,622984,424843,882094,492566,321956,515518,609554,542347,826059,709506,718099,224151,565224,600123,816042,17129,498534,377077,224181,152390,712410,134447,743521,177862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000785s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]