SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 643811 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 643811 [ RunTime:0.001417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26720,313782,927742,1033590,480416,608611,359164,318310,279725,1017850,92684,708885,151292,216098,869839,926876,14624,483201,293087,163209,377811,63350,978635,263792,128220,239247,760891,507660,201499,612546,827989,97155,309698,621501,477478,806599,736387,528203,412001,406302,964173,494835,284346,150306,111253,934580,7011,753985,267810,897999,439608,718568,30946,839662,307273,375609,931421,668503,952837,631093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 643811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 643811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]