SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591040 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591040 [ RunTime:0.002795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273744,213003,106116,496432,729826,786314,323743,958926,20300,183633,363974,1011887,473872,1005010,498152,461856,517029,939914,772297,711012,7315,959168,192520,379703,478540,91928,220258,818979,902257,195872,298823,696643,534719,936497,669075,43193,136964,462439,72302,512844,800182,347046,632859,316749,729315,281534,102317,71092,308293,441111,225107,678033,128044,152885,635404,1025184,573157,1000725,356717,561164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]