SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542310 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542310 [ RunTime:0.002592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619829,177012,1039768,262567,870629,84143,518554,1001359,760640,601621,272377,349065,501052,702845,904729,402410,688729,861340,578410,659880,70358,356668,470127,569540,385842,707282,776506,864985,264703,433457,597488,676355,279470,665137,1007321,394857,895564,142460,472282,821143,121918,362805,248156,439641,530409,862258,113018,364603,83797,354900,322301,298237,1033382,341819,25824,805416,934291,497630,759851,329486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]