SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028139 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028139 [ RunTime:0.002644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528455,985939,493937,3737,865135,45657,437298,1007777,28336,689732,648326,595489,447471,644291,426460,746487,391570,920646,383324,933679,351890,618916,347007,582630,542172,331634,1012696,173218,940529,238252,327023,778517,344860,71513,960267,175570,844133,77251,346846,39868,353602,477937,56015,473018,130831,930107,434936,627192,844210,208350,648324,18021,662594,1021142,417289,10735,858211,649778,32401,538482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003938s ]