SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805011 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805011 [ RunTime:0.005705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855039,799704,104708,623946,336488,868767,604780,956351,476892,560706,808971,744489,961160,379829,985149,552600,550701,649649,529599,878013,501712,451125,282802,515546,993160,670018,913987,782721,170319,141104,821850,110144,799443,490558,887371,263788,926702,1034408,351677,364536,282249,647834,479585,812969,395955,731276,261914,355586,871199,253811,286906,810699,111327,842037,873794,650857,99257,72570,79375,956110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]