SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320054 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320054 [ RunTime:0.002965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (970534,198484,261691,228981,136520,120807,4675,877156,846670,217465,847636,975011,663091,49793,6085,575886,462018,29279,982280,1005672,275238,376039,1018372,971402,1042800,215389,403576,305677,946982,281553,126739,271010,461159,58052,801135,794371,393845,733906,249989,540527,882173,318899,351299,754563,821224,664184,47340,929028,98504,815730,166115,121157,596045,776295,327782,107556,843966,890971,1034286,792822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320054 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320054 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]