SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423268 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423268 [ RunTime:0.003342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879824,421684,423056,160505,46054,849158,244600,765257,621535,373548,503494,248840,871647,415249,856140,45152,554236,5003,614654,661682,721740,976564,1043295,822247,379408,454980,883131,520864,62223,730887,56320,401830,218324,186730,295391,358308,456436,53657,302826,933486,500664,718078,85508,235722,445134,658435,1038136,402380,955609,853854,163710,966245,528191,420178,989969,156849,709994,679657,603642,582158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423268 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000683s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423268 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]