SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4814 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4814 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183121,978514,625285,301533,740869,763191,341654,493997,48688,758544,720052,31197,844734,926007,1008920,706412,880606,381051,129853,143451,924166,760871,412818,232049,76054,665773,291642,232258,751209,576752,473026,295946,922572,934786,1006283,527087,495560,47238,558666,956125,400720,557650,22853,213719,15554,271034,620302,298168,635700,61805,51241,347129,598749,787513,341648,5020,906163,108059,447789,703813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]