SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28180 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28180 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928121,440180,1023910,36654,443403,988788,103991,653427,361280,988275,789485,649499,870417,1024991,43828,842589,812086,208598,35950,373135,16842,500639,257580,997888,646044,539271,572077,199119,368526,682528,981492,727069,338310,743518,662162,27035,764861,548579,664323,289058,548139,454337,194867,39935,628149,954414,847149,293475,378141,744061,169927,529672,392740,837614,173171,507291,871172,653647,672566,865499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]