SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513940 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513940 [ RunTime:0.002119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961136,206484,414432,784021,843074,402984,297501,785246,338020,714463,400511,207860,358780,339140,629090,768657,605655,1030699,789193,418513,461793,692455,780871,420455,752449,837302,762911,555021,730681,506688,921515,784494,955158,888136,10302,189003,1037917,981851,1027324,1000080,568772,914624,254372,3586,452343,223398,645533,653957,922284,1043302,87719,321059,176610,316699,904914,664008,644561,246039,214984,802899) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]