SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421 [ RunTime:0.002962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030728,1041523,127515,649985,670251,358454,299418,396414,566295,629884,694146,196977,422947,675169,973921,135045,514358,500945,369497,79817,87120,228433,998526,70856,224217,915582,1032279,684653,1028776,675858,561001,151021,645824,1012356,449331,938094,640599,121244,693866,916638,113933,363934,1011193,37717,969697,959972,640604,893401,65612,570733,450111,155522,45993,208704,920942,235106,354147,12120,76217,859712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]