SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002028s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030970 LIMIT 1 [ RunTime:0.001308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030970 [ RunTime:0.004996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845340,384072,597001,289280,421053,504790,760801,985753,414042,800310,724429,144128,859599,90445,897252,61999,126527,371058,384159,727075,513067,169060,719999,542258,504308,36506,210351,716277,393117,582517,469791,799873,368935,810818,352895,356970,144339,478677,518522,321947,195661,713630,577622,900717,137858,334427,429904,294125,81248,164880,440312,775096,127522,147187,117514,858792,172591,197510,47828,534918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002160s ]