SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391999 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391999 [ RunTime:0.004739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416123,334160,19857,501028,1001623,765576,64179,400646,450234,778805,210624,232327,869202,69349,76311,77384,312789,896457,26719,776325,464820,1001059,926249,699336,931934,776153,219384,595210,854355,650050,147400,131212,441666,609687,722084,101587,244552,110561,690204,764710,3549,167784,50279,414538,911762,72510,536993,778579,202648,437083,846883,876353,193616,725097,254030,529867,1037680,862111,11767,28164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]