SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 388570 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 388570 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128367,564192,1022234,794060,656297,1034670,178992,714331,832935,736801,774608,344994,640888,47847,877810,612184,120297,938291,425597,139674,36727,60644,151554,921411,753762,788299,252639,958061,81086,352231,769115,877145,285681,1010575,1042106,923088,78503,908487,487620,353405,614921,680260,340563,958326,1003112,269922,54506,428126,731348,375346,71968,1009580,49231,417125,97991,1016607,1020912,891520,664155,5770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 388570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 388570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]