SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417281 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417281 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357197,51122,739101,628028,945831,428909,353619,736585,475851,696841,499093,818846,289873,343225,249244,213503,352315,217869,419542,165095,317000,786778,701824,960497,426000,266515,404905,811787,749381,1046614,937315,870238,950892,139150,804947,514186,149993,358178,534463,359271,926037,462121,412,574231,983266,108122,378003,483028,428643,823323,85541,795193,584443,249937,596651,717486,682177,44106,350804,392681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]