SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014370 LIMIT 1 [ RunTime:0.000524s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014370 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43636,954606,484794,244235,19567,51573,472314,452784,163399,688311,771497,403766,714890,447762,405614,791635,478236,636525,840764,881462,888709,516631,869405,995307,168138,532931,861748,534661,140326,1030376,504101,395895,448540,168712,890010,463354,368118,995950,724,160772,630312,90769,668216,150970,317734,174581,160037,286323,583650,796870,810281,869135,300105,897169,327085,791692,110229,850506,686169,642681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]