SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022588 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022588 [ RunTime:0.001461s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580197,345639,564816,911475,744626,402270,568076,649612,263001,443724,659624,930205,195551,365408,878107,831860,366623,119292,517804,346912,596593,739874,765368,913505,123672,886928,448686,887150,612387,297145,595189,345922,879825,285044,261775,973926,991795,785444,791011,771624,75574,684325,104768,557402,810250,982321,1004685,745326,40250,428970,1022620,241308,238219,506365,168224,665642,511471,57007,848178,704373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]