SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522230 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522230 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399560,410560,477098,19340,376903,712355,977488,323356,469024,159281,962334,310572,576624,891830,591147,641950,961869,521403,1017705,142074,579250,631861,27990,365025,508779,81394,849311,486283,101314,5918,398030,757268,79202,45139,642380,210232,273018,914188,487619,789400,812429,462260,564340,680486,941329,354517,704461,47806,27413,220570,415808,849315,656062,508787,823634,112042,147602,548764,864369,327719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]