SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573823 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573823 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56165,779518,71248,71302,716650,674157,197640,503542,915151,435026,400684,508329,172757,404183,753009,864019,358393,201979,564809,489052,219183,710689,988593,400646,851242,45906,759637,519074,663441,856691,14966,410810,869279,757976,300472,699094,331590,745791,958589,559750,170012,327607,874188,686596,226805,27061,504759,324661,790278,481048,32518,210572,530169,110661,369716,267144,383964,478402,129014,987013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]