SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10479 LIMIT 1 [ RunTime:0.001038s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10479 [ RunTime:0.002530s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004363,181591,265604,131341,55768,929610,361045,268118,704919,495665,370642,110201,921551,454404,235695,384423,22890,221983,455255,280699,898422,328691,994280,344106,927547,80746,604565,386269,327214,752252,586660,477332,393138,701674,656096,923490,852226,202360,617436,318157,973698,447462,211039,878596,129332,819239,256526,143225,82384,675428,441014,276068,346358,981378,607342,569852,846235,737162,407023,65837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10479 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10479 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]