SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201196 LIMIT 1 [ RunTime:0.001026s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201196 [ RunTime:0.003451s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240101,334519,596644,85674,891286,397330,140195,120036,540479,409412,492712,645280,641119,19555,650648,274123,218847,578534,117366,277785,804857,447356,1019856,329917,931988,773848,136568,446400,233557,122593,564623,262904,691615,921759,989031,466239,614416,653700,626652,410380,871841,75813,547928,822106,683240,882652,295197,567738,534458,101227,709663,207913,34416,176676,332899,891869,103781,943535,667837,604922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]