SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28653 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28653 [ RunTime:0.001940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969650,646860,152604,700341,115822,701571,523427,94274,571494,750955,464276,603617,1005554,940667,632523,375976,321804,293345,994459,136584,3727,934769,351144,791159,544928,841743,595525,183147,1001301,667964,359484,981729,335673,1040490,288670,167352,849163,554306,594662,633446,132925,946317,973578,410345,255070,755347,618581,267184,789728,217577,955181,944921,1021020,501019,730539,280672,118145,616337,51884,376063) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28653 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28653 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]