SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466271 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466271 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542273,499905,359343,1016362,800264,920085,561659,693275,396170,312671,831316,1040487,446657,286419,866286,272411,581398,950564,724962,102959,114304,192748,607835,1003440,148541,630448,341120,1035777,126996,1046221,776863,904509,177333,726193,227356,303300,1002661,890253,506215,235160,356987,681963,581428,137484,769668,156906,659086,772527,55411,699607,5995,262505,468979,300879,663340,372616,1014438,16357,363574,812318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001003s ]