SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412701 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412701 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515194,664272,904991,1016824,169012,971088,145275,360383,307462,1013731,751072,425307,654823,659298,688105,334918,376741,13967,796023,668057,869772,540717,395622,954211,314495,749572,696262,242927,12584,178231,290329,793675,574992,151102,681471,106991,288678,924103,705908,833314,169286,311983,455620,445348,785917,508984,720008,864342,1016773,49189,1029271,59615,152466,6701,813035,772584,200050,918810,1046784,714454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]