SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524280 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524280 [ RunTime:0.002545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (898844,243225,843418,697005,552398,94601,576278,1037175,770851,240767,356569,145736,83991,247275,985409,1019540,180982,421297,471679,189818,633241,142951,507167,32826,43796,160097,31375,447783,80257,64027,953278,1001714,27187,371171,932442,621219,964058,535984,476073,890163,39452,978691,1024949,820107,631092,572345,62515,706372,663706,829371,373456,456605,387453,938617,105384,967767,725658,648153,343024,791095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]