SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041112 LIMIT 1 [ RunTime:0.000649s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041112 [ RunTime:0.004747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (849893,747168,417442,89681,252622,170958,653332,317001,801967,863713,515474,567303,60051,491061,121865,63220,1021709,122728,656258,106658,913591,987646,98328,73392,787458,377498,273260,892985,151326,203074,513820,284406,71372,821177,226082,972453,920403,395374,814429,854444,392541,711445,676897,125034,133475,83134,179829,419509,589215,1006997,499772,872141,449240,467013,373651,286779,1033838,342349,1038173,544621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]