SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001697s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 936983 LIMIT 1 [ RunTime:0.000599s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 936983 [ RunTime:0.002497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577457,363041,652938,726871,559026,474021,988169,751751,80694,872585,395151,450199,973358,34780,491836,1033312,1031341,726566,459660,87230,385099,437154,322956,425795,438543,175467,686739,1040541,801740,701539,726068,442455,895081,186838,199463,1024647,86452,43551,42884,1016107,774907,517078,704098,188685,413802,930580,272083,481052,69567,402917,185703,513743,721881,561527,460307,317479,603434,360122,658862,81688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 936983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 936983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000938s ]