SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40186 LIMIT 1 [ RunTime:0.000275s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40186 [ RunTime:0.001974s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274079,1015345,829841,142925,1007723,238814,1019783,217230,361557,801116,411343,806802,508956,93881,845177,402695,543416,854177,343066,1001610,730024,426937,934878,534393,15166,165304,738973,474282,158545,922506,45431,619464,106857,558546,103282,689776,568785,466316,871459,399903,201946,988249,624158,303959,453143,667857,238554,173163,904303,489403,830616,927929,659609,184635,691851,334387,539810,791870,845692,158029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]