SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534092 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534092 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222659,317420,6321,835287,414955,739918,12148,624563,481538,290306,310144,918499,401489,256778,195649,895358,471229,1027551,558660,679649,114154,898301,867268,985642,983198,227509,326291,599991,108849,123388,3284,240271,379100,62693,139296,930038,687849,828442,180799,742722,443106,899830,785995,284279,117106,637127,523467,439665,1041436,492623,173693,362407,504509,816036,700424,885414,996209,558929,1010499,272338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]