SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401273 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401273 [ RunTime:0.002365s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740274,253524,30268,526224,383102,215955,849714,354775,296551,628007,933909,323216,382067,115411,486411,545758,305685,936600,430159,781191,214267,508528,617753,807278,262509,630423,673854,984818,754618,842653,1032484,254347,118560,96170,292951,346514,424843,447890,60948,243766,40670,42579,1015978,985346,400358,662592,518536,538262,367414,293846,669493,765404,700298,27809,121450,25293,144688,875902,246822,555712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003819s ]