SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006738s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043144 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043144 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97607,901359,206859,878192,962267,310606,91867,361517,711214,361867,333596,799760,619880,777043,203844,800910,523285,321317,212356,477544,1038094,1045041,314550,856012,40249,10724,989789,301630,866015,202366,585793,736290,273678,1025924,892578,259031,194768,1014654,21464,350716,123905,973457,51308,1028482,737180,769368,597372,225749,80064,727432,741363,471625,272269,539548,884765,293423,179315,851198,397578,556154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]