SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59544 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59544 [ RunTime:0.002316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002338,199135,26311,175428,978257,504496,37963,464672,100579,771209,678633,958577,97252,566093,666744,182989,527126,552402,666498,100292,1027528,903965,825267,490383,977070,649531,282846,592729,486487,451153,710283,717789,699949,880527,416101,647514,1032829,974247,144446,429644,482027,427195,918597,758735,100138,493886,1001383,545316,601356,384074,312039,558994,265712,452069,454847,146019,947599,446927,404453,729155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001110s ]