SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006549s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318901 LIMIT 1 [ RunTime:0.004942s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318901 [ RunTime:0.006609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809985,692256,850511,469446,278755,897846,1020104,750900,1023849,513831,952792,778437,148996,744560,155198,415504,724342,358077,602854,619831,682648,895761,139090,965400,1035348,780989,260316,549082,938330,163090,533127,254579,3457,6517,628295,872489,59223,373836,412452,126987,487454,401919,672532,1042181,765457,46038,934933,562386,719700,430146,731779,443579,730163,110265,431015,570104,102887,687769,63158,906158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]