SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331451 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331451 [ RunTime:0.002321s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430605,227374,246896,457261,109014,516352,621449,71176,464092,572280,52676,173470,870005,610782,985633,993749,224237,59618,535778,234086,566198,41820,576864,494308,460373,649547,797737,823637,106173,898071,255325,164657,544817,120526,88382,890809,98449,205410,817689,876689,249050,687918,366436,845533,339116,182042,746126,165073,654892,1004405,742013,809830,145396,89594,466923,543723,1046031,225334,140360,729965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]