SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436830 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436830 [ RunTime:0.005319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026340,94861,526035,402567,185444,810471,796506,540732,439044,547707,863786,620769,158874,260313,230346,697989,45015,180994,1027397,519258,633004,290445,47934,591366,663911,337970,161936,58978,745209,642405,743170,891302,271804,156358,854583,319735,708866,813157,143047,1022364,875164,709780,710529,547590,96571,242327,223927,248722,904876,1039626,763556,320436,990250,959703,667171,769317,831420,468600,282850,316018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]