SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338813 LIMIT 1 [ RunTime:0.000653s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338813 [ RunTime:0.004923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607161,795439,228367,464843,576443,211758,630471,616582,978763,935245,353393,497193,505697,324851,708738,542033,964275,712717,210887,339123,351444,703035,742973,470702,247751,492823,551668,401537,482386,677821,240892,979081,679348,285754,137120,982489,60012,235032,443452,777929,936097,38763,664658,945693,414092,1005984,123486,358117,835121,442208,632972,586532,343954,722405,946325,490363,178007,240094,62961,740178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]