SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458508 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458508 [ RunTime:0.002603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (272015,843252,462771,185433,629137,286573,864351,568794,408251,223459,1043808,290110,224753,190293,204663,430107,324861,939716,324138,261914,578826,887985,833558,154371,201338,98574,843170,441935,656899,87708,63293,936779,29222,229100,898090,689756,14171,701335,1042518,547635,796601,139218,54191,1013405,977863,201448,818753,196987,709762,470823,773876,298039,370752,543681,794888,551626,491722,737516,491718,246428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004426s ]