SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 444612 LIMIT 1 [ RunTime:0.002074s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 444612 [ RunTime:0.005539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828437,10120,826285,236890,41866,124075,76124,991764,601667,929829,925008,975861,334669,161912,720100,513434,231469,716848,829662,86800,27384,60249,879198,1043983,64284,137489,366814,603610,700451,734199,712886,683891,939115,864160,452115,1001372,350073,895130,36525,834205,709102,757203,183466,568589,237671,292040,531808,586824,459987,672864,369939,35982,408448,499393,239534,615913,355141,817482,251059,511685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 444612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 444612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]