SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503124 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503124 [ RunTime:0.001957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155258,1028345,421632,707031,161538,463739,967636,158061,631581,270108,940994,931736,309517,27422,868460,282349,421866,802477,316476,1042027,777186,50471,480474,554968,399459,705440,157794,970194,353180,311773,932634,466626,423830,970664,149296,610408,912930,949244,121189,304518,930876,372478,78613,606104,577580,209440,618362,502136,797832,68405,829438,382572,382205,837484,800847,551728,840390,845735,103923,753897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503124 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503124 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]