SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541410 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541410 [ RunTime:0.002408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992934,30824,5161,81176,525141,205451,225842,620407,900612,68161,929618,473805,202354,361334,436898,532388,208261,355289,291157,2198,32721,613281,393852,425162,937092,918886,674668,342987,345265,652363,693507,1035052,181660,210029,962276,616910,932377,981066,941543,599013,1041022,244643,920749,506375,558469,962258,273676,861999,862558,335341,128943,134302,166693,721520,450655,489313,945613,255406,67471,897639) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]