SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009813 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009813 [ RunTime:0.002055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183260,17167,130928,59124,456157,436152,720702,597306,492233,295036,805782,599017,650153,39462,587025,229018,350768,625160,203063,382123,931429,150846,527534,792172,449194,695429,203896,224930,544020,164601,845778,244738,195170,236868,365305,872317,980478,674043,41338,200881,992225,117216,954208,752311,360319,424547,308689,566917,73720,746795,160221,346590,124066,938748,400553,695220,437398,439518,396495,231395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]