SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539531 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539531 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (683909,1001424,594935,168676,664583,367486,809198,180165,643334,133134,391244,357582,674177,691527,680585,786068,910422,140992,509626,55825,452966,734945,464943,940398,126852,494500,648922,850420,1018689,696375,752052,515194,21970,340037,185964,292735,137376,978360,470677,159100,857103,377902,943071,756981,196644,590807,443517,399143,826003,937662,801011,824115,742475,444862,266422,184143,176518,930213,59312,686783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000738s ]