SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539585 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539585 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359983,24096,956507,618339,958324,845167,638919,270355,792458,173323,446987,982901,1041222,230378,418426,380178,844416,33951,6661,708257,567406,702480,89820,1037335,682492,803097,422522,655259,619169,651316,268865,65715,714475,628570,571463,523098,763445,249561,335567,796299,1034868,780467,626273,92828,211821,463501,254908,146501,583973,659332,135307,433303,448514,331965,466356,527329,320411,299391,838577,1014391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]