SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551508 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551508 [ RunTime:0.002985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543630,691006,383912,938218,268707,220850,828044,384063,356499,259149,1044803,1018145,75120,1020300,473831,584511,86325,842716,881176,505921,850020,887048,921722,969296,745872,369880,502631,375143,75286,894901,253526,314462,869205,943886,206025,581955,841858,973468,93625,2111,290815,1034207,378519,488388,472810,758498,159002,358498,676950,520806,891096,524227,309331,213348,491651,79420,899024,99740,1014718,37613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]