SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580504 LIMIT 1 [ RunTime:0.004222s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580504 [ RunTime:0.007154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661188,977896,613281,1014060,404158,42683,625845,556736,814475,134645,175289,217433,612149,929558,127525,639497,427870,247952,1022125,904372,439503,885801,866324,154789,632888,159670,872407,230408,94179,263828,696993,774707,257956,522868,544958,513051,662866,1040038,45204,739077,889059,9292,685205,397739,1040452,1013229,985045,747069,654232,330685,800302,792235,666123,267961,917532,588336,455649,357899,886702,802791) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007815s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003818s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001716s ]