SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285313 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285313 [ RunTime:0.002198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246888,595809,1032836,386725,250407,469304,731103,706503,657712,381149,1007789,147336,583550,161856,888540,247646,349943,332667,156038,359499,752322,723203,775495,374057,991641,885956,519879,583503,443886,121760,758398,174678,482646,137147,256522,955472,674502,602189,489988,558817,387093,694099,638418,50308,147001,454723,590072,948010,922286,653642,159618,897815,167176,392106,558831,829028,980347,1045508,564656,702342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]