SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001891s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520393 LIMIT 1 [ RunTime:0.002159s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520393 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012689,370836,659732,88545,763355,776399,889190,693444,582186,195537,863899,765486,572508,129605,297371,375868,717512,741469,777421,762597,352679,155383,886978,965933,963903,264530,817584,738872,423466,362681,630810,419729,129137,709567,201215,806702,1043523,179149,894655,669091,984259,756964,865208,660839,225025,915671,821864,325621,438634,530880,796104,901673,339347,561266,156589,681369,863777,670845,669618,26029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005829s ]