SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281808 LIMIT 1 [ RunTime:0.001020s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281808 [ RunTime:0.002510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892039,571678,671057,238810,289957,459206,95355,821744,531569,969888,979485,286227,78165,638904,674398,258743,1046596,765271,118537,796761,1031415,692669,576206,881682,172893,720573,401792,203691,604809,890604,775789,460417,767632,798511,685063,1035127,45388,949806,71161,984097,572258,507268,319709,417448,540582,177337,738905,967527,234486,427781,292284,42558,722111,200660,1014713,324358,451842,798052,1024236,697604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]