SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001326 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001326 [ RunTime:0.003132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489841,16238,790162,833065,654722,795134,75184,240181,531123,554057,465021,798881,66343,231581,210915,473486,312546,826011,936910,915782,827182,581017,161297,864789,92171,826825,620678,517967,353453,780574,652372,770037,693319,664379,202652,767052,426451,837613,765564,18257,196510,347590,531984,56847,826705,846420,902409,822183,133047,940995,298246,422927,135662,1045829,837263,363721,905270,478922,873820,589576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000767s ]