SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523987 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523987 [ RunTime:0.002234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91093,405277,43874,996925,207729,158450,1008801,689158,850061,517803,850078,520894,262464,807077,124400,788718,19009,345103,636633,426930,815528,694358,37526,754199,894902,335658,491144,298757,895339,696871,124340,1023140,371752,23679,1035350,193860,987920,158994,462016,932198,159873,614080,96016,361837,751222,56601,510778,159839,798767,740322,556742,624762,611222,709916,458011,183389,223968,1016170,1000684,456244) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]