SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012060 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012060 [ RunTime:0.009531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167216,349471,375881,756937,840333,747361,15952,771905,641015,235183,320112,32500,991657,856906,968540,710987,860015,683836,318295,107058,827013,178936,422141,631016,140055,499043,15755,755389,707902,506800,908434,584630,13098,134484,11125,533504,731783,941688,227302,899098,609311,848243,14534,979448,699772,480638,627402,392399,976605,347945,422746,26474,606709,616611,536721,847563,891240,97599,670997,220984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]