SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001082 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001082 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393276,44861,1030834,686901,382429,240190,902081,96306,1026109,45260,857707,971157,60627,739080,423294,244103,802419,351914,949004,600573,351153,183408,211355,425838,340709,587642,2451,528715,1029381,576778,875771,138371,590311,174816,190809,946259,924224,565902,618506,1006689,628628,687208,790084,495694,199130,281289,772104,768692,1033053,972846,198927,586795,27528,1035918,851722,517701,339948,881990,555748,518559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]