SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016169 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016169 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100277,261522,926924,749762,626070,222365,824430,780988,13194,516636,499430,987306,318722,280213,405092,1025268,842330,807528,675739,651363,115456,574709,893913,986367,204601,622192,829850,574476,771470,313190,319020,655477,597592,730967,447757,862291,240438,387141,602696,292206,485294,568238,642348,914497,283825,252147,12916,835257,241859,14868,40016,664129,977319,184144,388454,925929,833805,160509,235146,200198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]