SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455964 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455964 [ RunTime:0.001314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602423,194679,878826,544892,631855,357594,901219,754008,663644,115273,147610,27129,1026283,539226,957291,235443,1024747,59536,451210,123701,445216,216543,833077,1018085,220829,830152,459189,1014168,36804,659216,1046617,54670,503129,733485,861907,687183,1009693,651862,806860,461698,37799,683888,602383,605979,155415,151512,976001,493805,811587,644894,268857,420412,437885,221531,235782,120063,925194,618561,516603,476877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]