SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003713s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474473 LIMIT 1 [ RunTime:0.009606s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474473 [ RunTime:0.010491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907288,110276,556610,79395,494419,1011827,512906,854339,171219,608302,41904,1035802,1016351,810276,829872,793296,109678,687789,915104,294853,260043,529505,807771,393377,555018,485559,557902,365028,462983,341038,940133,122917,724801,208478,578459,304982,811400,185872,819774,754351,917776,249972,645730,1011417,152295,935063,543007,943607,866002,614990,836490,1012481,187776,589052,735040,667316,580102,293061,38343,506033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002753s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]