SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201395 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201395 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910576,47621,789391,631778,901261,834436,445684,864130,154534,25416,856870,478418,185491,677273,879562,37515,1030346,954187,1006184,1018867,931586,415142,893276,170824,428775,906303,732810,281181,96422,944321,1027005,240787,1028083,3023,1039678,151793,1010669,77301,17057,863427,622472,706112,995666,933947,716044,835410,623400,624427,968492,956291,67327,468699,221055,335940,442594,625376,583488,816120,825699,110325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201395 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201395 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]