SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399272 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399272 [ RunTime:0.003930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111062,352653,1033231,181843,793774,691043,341487,993066,827696,608593,351640,28644,437263,960498,434705,675088,688743,865892,469978,997442,500009,171608,172153,149884,1003587,384286,874755,1029534,596706,441416,173048,983564,514750,309464,721415,167665,480621,92736,1019424,363921,773913,129791,526,361599,504513,654957,935202,842123,864953,760324,79057,681207,508373,111476,252422,619867,97779,644775,508684,1026567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]