SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 173179 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 173179 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519207,215065,285095,995183,815211,1029839,671935,190001,151769,201013,3167,577175,246995,446778,753790,68906,567474,430105,969386,73302,26031,179583,715739,490190,949097,204071,1044320,966261,91416,597260,895042,802411,772680,227416,682652,820322,763873,454746,1529,432198,474017,333817,121616,930056,38397,559081,489172,780463,823464,34873,902693,945808,489170,692828,551808,517926,297798,112890,209947,478589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 173179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 173179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]