SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3081 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3081 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933087,244851,368448,109913,274190,652356,462329,227563,657225,438080,591571,680698,755029,808433,979243,425988,965485,12468,987846,881104,330722,39574,116189,414141,659906,971232,181519,283392,265851,51833,498771,796422,233517,1039527,258240,172647,62777,179713,172803,866811,379176,570503,994608,1038880,474802,740619,631085,804481,129502,240378,17911,207092,359639,659922,785246,1025446,30136,67348,300439,961694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001448s ]