SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043380 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043380 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (705702,1041314,321751,692796,835022,977972,300340,676700,255303,950094,945575,779829,342442,382168,298664,435740,746797,767967,336769,579390,841929,510560,628028,56913,364352,229351,22598,888867,661447,237047,453666,538565,68204,628336,282149,87425,805897,355548,670884,399238,1036029,154528,335685,366835,988424,20618,632865,293720,135637,440463,568291,777682,566760,635998,790409,798177,42344,662080,764963,608520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]