SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536748 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536748 [ RunTime:0.007499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584472,218508,909445,328870,748990,1013538,1023204,329384,696076,379812,765416,276928,951873,103298,1041549,174032,992878,408629,514313,47656,635704,645696,343579,225326,387019,238424,663894,657667,295891,844252,792308,367918,584309,387026,63414,823953,658193,120134,115985,804245,766177,644623,96195,129848,967429,309717,465,890723,474332,187690,483318,594718,229337,914921,63636,283244,463505,350680,1005787,428114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]